Oracle APEX

I would definitively use APEX for small (department size) applications that can be developed and maintained by a small development team, without a complex design/develop/test/deploy process.
Also, to generate all basic CRUD on complex applications, rather than programming them using other languages (Java. c#, etc) and having more complex deployment processes.

Very well suited for medium enterprise applications.

If you need rapid application development, this is the tool that you need. It is easy to use, and you can develop an application easily and fast. But they should really improve the version control, sometimes its hard to use.

Oracle Application Express is great for small applications, where you have a few pages. You upload an excel file, create a interactive grid, create user authorization and everybody can work on this grid. You can develop an application in hours or a few days.

I think it's less appropriate when a customer has a lot of special front-end wishes. In this case, it would be better to start with Angular and generate the front-end all manually.

It is appropriate for database application development supporting data driven processes, online transaction processing, BI/reports/analytics ... for addressing about any business data processing need I can think of. Oracle Application Express is fantastic for creating beautiful rich user interfaces with support for all major browsers rendering well on a range of devices. It is less appropriate for applications requiring native low level access to device peripherals and is less appropriate for applications that must execute offline without network/internet connection to supporting application and database servers.

Oracle Application Express can essentially be used for any web application that needs to talk to an Oracle Database. Simple applications to view/edit data can be turned out in next to no time with the built-in reports allowing fine-grained control for the end user. It really shines when used for tasks such as dashboard management or basic manipulation of data, all of which can be done with next to no code.

For less standardized tasks, the architecture will allow the use of other web technologies. I have, for instance, incorporated Google Maps into Oracle Application Express in order to visually show data, such as the operating areas, for our consultants. Setting this up in the Application Express framework is relatively straightforward allowing me to concentrate on the heavy lifting in PL/SQL.

The only major area I've found that it isn't well suited in currently is outputting anything printable, typically requiring the use of some 3rd party hardware or Oracle BI (if money is no object). I have also run into issues when working with larger teams as it doesn't lend itself well to source control with all the pages being stored in the database itself.

Almost any business requirement with data-centric aspects can be covered - no limitations.
ERP, CRM, HCM, Financials, mobile apps.

It is very good when you have an application like Forms and need additional functionality (features) that you can't have in forms (dashboards, predefined IR with charts). It's a good use of external sources (web sources, REST API) and ata visualization. I haven't tried it yet, but I don't know how it functions in complex pages (a lot of client controls, few hundred fields). For example, we have physician reports or discharge summaries, and nurse documentation about the care of a patient.

No matter where you live, you can build scalable, secure enterprise apps. If you want to work in the same workspace as your team, you will need an Internet connection.

It's well suited if you need to display (or enter/change) data from an Oracle database. If you (or your customer) think you definitely need a native app, then it is not a good fit. Creating a dashboard with different kinds of charts and KPI's is easy using APEX. If you need a real data-mining solution, then you better switch to Oracle Analytics. As APEX offers an easy interface for RESTful services, you can also create forms, reports, and charts upon any RESTful service that's available on the internet -- either within or outside your organization.

If you need an application linked to an Oracle database, use APEX.

It is a nice and inexpensive tool, ideal to extend the functionality of the systems, and offer users good reports, graphics and easy-to-use applications, developed with speed and low maintenance cost. We don’t use it when we have to customize standard processes in our ERP, mainly because we are SOX compliant, and it is more difficult to us to prove our auditors that we respect and accomplish with all the validations and controls they demand.

I would recommend it completely if you need the production of functional sites quickly. Simple approvals flow through different hierarchical levels can be simulated through groups and roles, but if the need is more complex flows for robust systems, I would advise opting for other programming frameworks.

We needed an app system pronto and so with our switch to Oracle it worked out perfectly for us. We had been developing our database systems beforehand and so we were ready for the roll out without having to add any additional time or stress. APEX would not be well suited to any company that is not wholly committed to Oracle, though.

Well suited for small teams of developers for very small applications Also good to prototype using this tool and moving to another one that has cross platform and vendor support. It is included with ORACLE RDBMS so no additional costs or licensing required to use the product. It is scalable from PCs to RAC systems.

Well suited to data entry and reporting. great for replacing small departmental spreadsheet applications in very quick time - up and running in minutes but I've also been involved in large-scale projects with thousands of users so scalability isn't a problem. One of the best things is that users love using Apex applications - I was told today by a user that it doesn't feel like working when she uses my applications.

Oracle APEX is very well suited if you want to bring old forms applications into the modern web landscape - they allow database developers with little to no skill in web development to create applications that can be easily distributed through E-Business responsibilities.

APEX also allows you to reduce silo working through the development of Access and Spread-sheet based data collection - with APEX you can easily re-design these applications and distribute across the internet making them global. Out of the box this can be done in a secure and logical manner.